package com.topisv.tms.repository.work.prepkg;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import com.topisv.tms.entity.work.prepkg.PrepkgPkgItem;

/**
 * 包装任务明细（预包装流程）_DAO
 * @author ch
 *
 */
public abstract interface PrepkgPkgItemDao extends PagingAndSortingRepository<PrepkgPkgItem, Long>, JpaSpecificationExecutor<PrepkgPkgItem>
{

	@Query("select t from PrepkgPkgItem t where t.taskCode=?")
	List<PrepkgPkgItem> loadByTaskCode(String taskCode);

	@Query("select t from PrepkgPkgItem t where t.planCode=?")
	List<PrepkgPkgItem> loadByPlanCode(String planCode);
}